County Profile for Franklin - 2018



County Controls Information

Cost Report Counts Population
Total Hospital Count 1 Total Population on July 31, 2018 0
Total Cost Reports Filed in 2018 1 Total Births 0
Total Cost Reports Submitted 0 Total Deaths 0
Total Cost Reports Settled 1 Net Population Natural Change 0
Total Cost Reports Reopened 0 Total International Migration 0
Total Cost Reports Ammended 0 Total Domestic Migration 0
Total Cost Reports Audited 0 Total Residual 0
Net Population Change 0

County Financial Statements - Worksheet G

Balance Sheet Income Statement
Current Assets 20,473,621 Total Charges 246,656,746
Fixed Assets 52,936,502 Contract Allowance 152,943,593
Other Assets 2,058,987 Operating Revenue 93,713,153
Total Assets 75,469,110 Operating Expenses 101,008,935
Current Liabilities 12,155,396 Operating Margin -7,295,782
Long Term Liabilities 27,270,906 Other Income 7,900,988
Total Equity 36,042,808 Other Expense 0
Total Liabilities and Equity 75,469,110 Net Profit or Loss 605,206

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $20,774 Revenue per Bed $1,115,633 Revenue per Person $93,713,153
Net Margin per Discharge ($1,617) Net Margin per Bed ($86,855) Net Margin per Person ($7,295,782)
Net Profit per Discharge $134 Net Profit per Bed $7,205 Net Profit per Person $605,206
Net Fixed Assets per Discharge $11,735 Net Fixed Assets per Bed $630,196 Net Fixed Assets per Bed $52,936,502
Long Term Debt per Discharge $6,045 Long Term Debt per Bed $324,654 Long Term Debt per Person $27,270,906
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 57.4 %
Length of Stay 4 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 1,063 Net Fixed Assets 918 Population Estimate 1,151
Total Revenue 997 Long Term Liabilities 867 Total Patient Discharges 846
Net Margin 2,744 Total Patient Beds 986
Net Profit or Loss 1,355

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 23,282,563 23,885,357 0.9748
31 Intensive Care Unit 2,479,819 1,959,844 1.2653
32 Coronary Care Unit 0 0
43 Nursery 907,469 1,472,200 0.6164
44 Skilled Nursing Care 0 0
50 Operating Room 3,055,239 4,385,254 0.6967
51 Recovery Room 3,021,444 3,024,787 0.9989
52 Labor and Delivery Room 464,303 4,963,742 0.0935

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 3,974,313 13 Nursing Administration 975,285
02,03 Captial Related - Movable Equipment 2,392,002 14 Central Services and Supply 6,477,654
04 Employee Benefits 7,059,520 15 Pharmacy 6,682,327
05 Administrative and General 16,902,062 16 Medical Records and Medical Library 933,534
06 Maintenance and Repairs 4,894,557 17 Social Services 214,710
07 Operation of Plant 0 18 Other General Service Expense 0
08,09 Laundry, Linen and Housekeeping 1,836,526 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 1,402,167 20,21,22,23 Education Programs 0
Total General Service Cost Centers 53,744,657

County Profile for Franklin - 2018